IF exists(SELECT * FROM dbo.sysobjects WHERE name='PV_klasinfo' AND xtype='P') 
BEGIN
	DROP PROCEDURE PV_klasinfo
END
GO

CREATE  procedure PV_klasinfo
(@klas varchar(5))
as

select klas,school,studierichting,notulerichting,notulejaar,
       schoolnummer,graad,directeur
from leerlingen..vertaaltabelKlas
where klas like @klas